Scenario Properties

Properties

BorderColor Contains the color of a border that is displayed around a scenario that belongs to a scenario table.
Comment Contains the comment about a scenario.
CopyBack Specifies whether data is copied back into a scenario table if another scenario is activated. The defined values are: -false: data is not copied back into a scenario table if another scenario is activated. -true: data copied back into a scenario table if another scenario is activated. The default value is true.
CopyFormulas Specifies whether formulas are copied from a scenario table to a destination table. The defined values are: -false: only values resulting from formulas are copied. -true: formulas are copied. The default value is true.
CopyStyles Specifies whether styles are copied from a scenario table to a destination table together with the data. The defined values are: -false: styles are not copied with data. -true: styles are copied with data. The default value is true.
DisplayBorder Specifies whether to display a border around a scenario that belongs to a scenario table. The defined values are: -false: border is not displayed. -true: border is displayed. The default value is true.
IsActive Specifies whether a scenario that belongs to a scenario table is active. The defined values are: -false: scenario that belongs to a scenario table is inactive. -true: scenario that belongs to a scenario table is active.
IsProtected Specifies whether the data that is displayed within the scenario is protected from being edited. The attribute is only evaluated if the table on which the scenario displayed is also protected. The defined values for the table:protected attribute are: -false: data is not protected. -true: data is protected.
Ranges Contains the table range that is displayed as a scenario. The value of this attribute is a white space separated list of cell range addresses.

See Also